﻿CREATE PROCEDURE [dbo].[Employee_Update]
@EmployeeID uniqueidentifier
, @ModifiedBy uniqueidentifier
, @DesignationID uniqueidentifier
, @DivisionID uniqueidentifier
, @PersonID uniqueidentifier
, @EmployeeNumber varchar (24)
AS
BEGIN

UPDATE [dbo].[Employee]
SET  [ModifiedBy] = @ModifiedBy
, [DesignationID] = @DesignationID
, [DivisionID] = @DivisionID
, [PersonID] = @PersonID
, [EmployeeNumber] = @EmployeeNumber
, [ModifiedDate] = GETDATE()
WHERE [Deleted] = 0
AND [EmployeeID] = @EmployeeID


END
